package com.ncloud.act.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import com.ncloud.act.entity.ChnlSales;

@Mapper
public interface ChnlSalesMapper{

	@Select("SELECT sale_id, chnl_id, user_id, job_title, remark FROM sys_sales "
			+ "where user_id = #{user_id} ")
	@Results({
		@Result(column="sale_id",property="sale_id"),
		@Result(column="chnl_id",property="chnl_id"),@Result(column="user_id",property="user_id"),
		@Result(column="job_title",property="job_title"),@Result(column="remark",property="remark")})
	List<ChnlSales> getChnlSalesByUserID(Long user_id);
}
